Character Functions are INITCAP, UPPER, LOWER, SUBSTR & LENGTH. Additional functions are GREATEST & LEAST. Group Functions returns results based upon groups of rows rather than one result per row, use group functions. They are AVG, COUNT, MAX, MIN & SUM.
Is it helpful?
Add CommentView Comments
Ques 37. TTITLE & BTITLE
TTITLE & BTITLE are commands to control report headings & footers.
Is it helpful?
Add CommentView Comments
Ques 38. COLUMN
COLUMN command define column headings & format data values.
Is it helpful?
Add CommentView Comments
Ques 39. BREAK
BREAK command clarify reports by suppressing repeated values, skipping lines & allowing for controlled break points.
Is it helpful?
Add CommentView Comments
Ques 40. COMPUTE
command control computations on subsets created by the BREAK command.